<?php require_once('connections/con_gl.php'); ?>

<?php

cekAkses($_SESSION[akses],"PJ-1-1");

mysql_select_db($database_con_gl, $con_gl);

$query_kontak = "SELECT id, nama, type, tcustomer FROM gl_kontak where gl_kontak.type='Customer' ORDER BY type, nama ASC";

$kontak = mysql_query($query_kontak, $con_gl) or die(mysql_error());

$row_kontak = mysql_fetch_assoc($kontak);

$totalRows_kontak = mysql_num_rows($kontak);



// ---

mysql_select_db($database_con_gl, $con_gl);

$query_gudang = "SELECT id, gudang FROM gl_gudang";

if(!strstr($_SESSION[akses],'A-1-4')) {

	$query_gudang .= " where id='$_SESSION[lokasi]'";

}

$query_gudang .=" ORDER BY gudang ASC";

$gudang = mysql_query($query_gudang, $con_gl) or die(mysql_error());

$row_gudang = mysql_fetch_assoc($gudang);

$totalRows_gudang = mysql_num_rows($gudang);



mysql_select_db($database_con_gl, $con_gl);

$query_satuan = "SELECT id, satuan FROM gl_satuan ORDER BY satuan ASC";

$satuan = mysql_query($query_satuan, $con_gl) or die(mysql_error());

$row_satuan = mysql_fetch_assoc($satuan);

$totalRows_satuan = mysql_num_rows($satuan);



mysql_select_db($database_con_gl, $con_gl);

$query_kelom = "SELECT id, kelompok FROM gl_kelompok where jual=1 AND gudang='$_SESSION[lokasi]' ORDER BY kelompok ASC";

$kelom = mysql_query($query_kelom, $con_gl) or die(mysql_error());

$row_kelom = mysql_fetch_assoc($kelom);

$totalRows_kelom = mysql_num_rows($kelom);



mysql_select_db($database_con_gl, $con_gl);

$query_klas = "SELECT kd, klasifikasi, keterangan, neraca, ruglab, tipe FROM gl_klas where tipe = 6 ORDER BY kd,klasifikasi ASC";

$klas = mysql_query($query_klas, $con_gl) or die(mysql_error());

$row_klas = mysql_fetch_assoc($klas);

$totalRows_klas = mysql_num_rows($klas);



mysql_select_db($database_con_gl, $con_gl);

$query_def_ak = "SELECT gl_gudang.a_piu FROM gl_gudang where id='$_SESSION[lokasi]'";

$def_ak = mysql_query($query_def_ak, $con_gl) or die(mysql_error());

$row_def_ak = mysql_fetch_assoc($def_ak);

$totalRows_def_ak = mysql_num_rows($def_ak);



$totdeb = 0;

$totkre = 0;

?>

<link rel="stylesheet" type="text/css" href="css/ui.datepicker.css"/>

<script type="text/javascript" src="js/ajax_data.js"></script>

<script type="text/javascript" src="js/ui.datepicker.js"></script>

<script type="text/javascript">

<!--

$(function()

      {

        $('.calendar').datepicker({

            appendText : "yyyy/mm/dd",

            dateFormat : 'yy/mm/dd'

          });

      });

</script>

<script type="text/javascript">

$(document).ready(function() {



	$().ajaxStart(function() {

		$('#loading').show();

		$('#result').hide();

	}).ajaxStop(function() {

		$('#loading').hide();

		$('#result').fadeIn('slow');

	});



	$('#add').submit(function() {

		$.ajax({

			type: 'POST',

			url: $(this).attr('action'),

			data: $(this).serialize(),

			success: function(data) {

				$('#result').html(data);

			}

		})

		return false;

	});

  $('#result').click(function(){

  $(this).hide();

  });

})

</script>

<div id="loading" style="display:none;"><img src="images/loading.gif" alt="loading..." /></div>

<div id="result" style="display:none;"></div>

<h1>Tambah Penjualan</h1>

<form action="proses/penjualan.php?act=add" method="post" name="add" id="add">

  <table width="98%" border="0" align="center" cellpadding="5" cellspacing="0" class="datatable">

    <tr valign="top">

      <td width="12%" align="right">No. Referensi :</td>

      <td width="32%"><div id="refDiv">

        <label>

        <input name="noreferensi" type="text" id="noreferensi" value="SJ<?php echo time();?>" size="20" maxlength="20" onchange="cekReferensi(this.value);"/>

        </label>

      </div></td>

      <td width="12%" align="right">Akun Putang : </td>

      <td><label>

        <select name="akunkredit" id="akunkredit">

          <?php

do {  

?>

          <?php

mysql_select_db($database_con_gl, $con_gl);

$query_akun = "SELECT id, akun, klasifikasi, keterangan FROM gl_akun where klasifikasi = '$row_klas[kd]'";
if(!strstr($_SESSION[akses],'A-1-4')) {
	$query_akun .= " AND gudang='$_SESSION[lokasi]'";	
}
$query_akun .= " ORDER BY id,akun ASC";

$akun = mysql_query($query_akun, $con_gl) or die(mysql_error());

$row_akun = mysql_fetch_assoc($akun);

$totalRows_akun = mysql_num_rows($akun);
if($totalRows_akun > 0) { 
?>

          <option value="" style="background:#EEEEEE; font-weight:bold;"><?php echo $row_klas['klasifikasi'];?></option>

          <?php do { ?>

          <option value="<?php echo $row_akun['id']?>" <?php if($row_def_ak[a_piu]==$row_akun['id']) { ?>selected="selected"<?php } ?>>-<?php echo $row_akun['akun']?></option>

          <?php } while ($row_akun = mysql_fetch_assoc($akun)); } ?>

          <?php

} while ($row_klas = mysql_fetch_assoc($klas));

  $rows = mysql_num_rows($klas);

  if($rows > 0) {

      mysql_data_seek($klas, 0);

	  $row_klas = mysql_fetch_assoc($klas);

  }

?>

        </select>

      </label></td>

    </tr>

    <tr>

      <td align="right" valign="top">Tanggal :</td>

      <td valign="top"><label>

      <input name="tanggal" type="text" class="calendar" id="tanggal" value="<?php echo date("Y/m/d");?>" size="20" maxlength="15"/>

      </label></td>

      <td align="right" valign="top">Lokasi Kantor :</td>

      <td valign="top"><select name="gudang" id="gudang">

        <?php

do {  

?>

        <option value="<?php echo $row_gudang['id']?>"><?php echo $row_gudang['gudang']?></option>

        <?php

} while ($row_gudang = mysql_fetch_assoc($gudang));

  $rows = mysql_num_rows($gudang);

  if($rows > 0) {

      mysql_data_seek($gudang, 0);

	  $row_gudang = mysql_fetch_assoc($gudang);

  }

?>

      </select></td>

    </tr>

    <tr>

      <td align="right" valign="top">Customer :</td>

      <td valign="top"><label>
        <input name="qtxt" type="text" id="qtxt" value="Cari data ..." size="10" maxlength="100" onclick="this.value='';" onkeypress="browseKontak('Customer');"/>
      </label>
        <label id="divKontak">

      <select name="dari" id="dari" onchange="setKeterangan(this.value);">

        <option value="">Pilih Customer</option>

        <?php

do {  

?>

        <option value="<?php echo $row_kontak['id']?>"><?php echo $row_kontak['nama']?></option>

        <?php

} while ($row_kontak = mysql_fetch_assoc($kontak));

  $rows = mysql_num_rows($kontak);

  if($rows > 0) {

      mysql_data_seek($kontak, 0);

	  $row_kontak = mysql_fetch_assoc($kontak);

  }

?>

      </select>

      </label><?php if(strstr($_SESSION['akses'],"DD-2")) { ?><a href="index.php?component=kontak&cr_klas=Customer&open=window" onclick="NewWindow(this.href,'name','1080','525','yes');return false"><img src="images/select.png" hspace="2" border="0" /></a><?php } ?></td>

      <td align="right" valign="top">Jatuh Tempo :</td>

      <td valign="top"><label>

        <input name="jatuhtempo" type="text" class="calendar" id="jatuhtempo" value="<?php echo date("Y/m/d"); ?>" size="20" maxlength="15"/>

      </label></td>

    </tr>

    <tr>

      <td align="right" valign="top">Check Out :</td>

      <td valign="top"><label>

        <input name="waktucheckin" type="text" id="waktucheckin" size="5" maxlength="5" class="jam"/>

      </label>

        <label>

        <input name="checkin" type="text" class="calendar" id="checkin" value="<?php echo date("Y/m/d");?>" size="20" maxlength="15"/>

      </label></td>

      <td align="right" valign="top">Check In :</td>

      <td valign="top"><label>

        <input name="waktucheckout" type="text" id="waktucheckout" size="5" maxlength="5" class="jam"/>

      </label>

        <label>

        <input name="checkout" type="text" class="calendar" id="checkout" value="<?php echo date("Y/m/d"); ?>" size="20" maxlength="15"/>

      </label></td>

    </tr>

    <tr>

      <td align="right" valign="top">&nbsp;</td>

      <td valign="top">&nbsp;</td>

      <td align="right" valign="top">Keterangan :</td>

      <td valign="top"><div id="divKeterangan">

        <textarea name="keterangan" cols="40" rows="2" id="keterangan">Daftar Transaksi Jurnal Penjualan</textarea>

        <input name="cid" type="hidden" id="cid" value=""/>

      </div></td>

    </tr>

    <tr>

      <td colspan="4" align="right"><div id="ajaxDiv">

        <table width="100%" border="0" cellspacing="0" cellpadding="5" class="datatable">

          <tr>

            <th width="42%" align="center"><strong>Barang - Kendaraan</strong></th>

            <th width="5%" align="center"><strong>Satuan</strong></th>

            <th width="5%" align="center"><strong>Jumlah</strong></th>

            <th width="8%" align="center"><strong>Harga Satuan </strong></th>

            <th width="5%" align="center"><strong>Diskon</strong></th>

            <th width="6%" align="center"><strong>Total</strong></th>

            <th align="center"><strong>Transaksi</strong></th>

            <th width="6%" align="center"><strong>Aksi</strong></th>

          </tr>

          <tr valign="top" bgcolor="#FFFFFF">

            <td align="left" style="background:none;border:none;"><label>

              <select name="barang" id="barang" style="width:240px;" onchange="getListKendaraan();">

                <?php

do {  

mysql_select_db($database_con_gl, $con_gl);

$query_getpro = "SELECT id, barang, keterangan FROM gl_barang where kelompok='$row_kelom[id]' order by barang";

$getpro = mysql_query($query_getpro, $con_gl) or die(mysql_error());

$row_getpro = mysql_fetch_assoc($getpro);

$totalRows_getpro = mysql_num_rows($getpro);

?>

                <?php

 if($totalRows_getpro  > 0) { ?>

                <option value="" style="background:#DDDDDD;font-weight:bold;"><?php echo $row_kelom['kelompok']?></option>

                <?php do { ?>

                <option value="<?php echo $row_getpro['id']; ?>" title="<?php echo $row_getpro['keterangan']; ?>"> - <?php echo $row_getpro['barang']; ?></option>

                <?php }  while ($row_getpro = mysql_fetch_assoc($getpro)); ?>

                <?php } ?>

                <?php

} while ($row_kelom = mysql_fetch_assoc($kelom));

  $rows = mysql_num_rows($kelom);

  if($rows > 0) {

      mysql_data_seek($kelom, 0);

	  $row_kelom = mysql_fetch_assoc($kelom);

  }

?>

              </select>

            </label>

              <label id="divListKendaraan">

                <select name="kendaraan" id="kendaraan" style="width:240px;">

                  <option value="">Pilih Kendaraan</option>

                </select>

              </label></td>

            <td align="center" style="background:none;border:none;"><label>

              <select name="satuan" id="satuan">

                <?php

do {  

?>

                <option value="<?php echo $row_satuan['id']?>"><?php echo $row_satuan['satuan']?></option>

                <?php

} while ($row_satuan = mysql_fetch_assoc($satuan));

  $rows = mysql_num_rows($satuan);

  if($rows > 0) {

      mysql_data_seek($satuan, 0);

	  $row_satuan = mysql_fetch_assoc($satuan);

  }

?>

              </select>

            </label></td>

            <td align="center" style="background:none;border:none;"><label>

              <input name="jumlah" type="text" id="jumlah" onchange="javascript:this.form.total.value=(this.form.jumlah.value * this.form.hargasatuan.value) - (this.form.jumlah.value * this.form.hargasatuan.value * this.form.diskon.value / 100);" size="5" maxlength="5"/>

            </label></td>

            <td align="center" style="background:none;border:none;"><label id="divHargaKendaraan">

              <input name="hargasatuan" type="text" id="hargasatuan" onchange="javascript:this.form.total.value=(this.form.jumlah.value * this.form.hargasatuan.value) - (this.form.jumlah.value * this.form.hargasatuan.value * this.form.diskon.value / 100);" size="10" maxlength="10"/>

            </label></td>

            <td align="center" style="background:none;border:none;"><label>

              <input name="diskon" type="text" id="diskon" onchange="javascript:this.form.total.value=(this.form.jumlah.value * this.form.hargasatuan.value) - (this.form.jumlah.value * this.form.hargasatuan.value * this.form.diskon.value / 100);" value="0" size="2" maxlength="3"/>

              </label>

              %</td>

            <td align="center" style="background:none;border:none;"><label>

              <input name="total" type="text" id="total" size="10" maxlength="15"/>

            </label></td>

            <td align="center" style="background:none;border:none;"><label>

              <textarea name="transaksi" cols="30" rows="2" id="transaksi"></textarea>

            </label></td>

            <td align="center" style="background:none;border:none;"><label></label>

                  <label>

                  <input name="add" type="button" id="add" value="&nbsp;" onclick="ajaxManagePenjualan('Tambah');" class="checkbutton" title="Tambah Transaksi"/>

                  <input name="ntotal" type="hidden" id="ntotal" />

                  <input name="bayar" type="hidden" id="bayar" />

                  <input name="tsk" type="hidden" id="tsk" value="add" />

                </label></td>

          </tr>

        </table>

      </div></td>

    </tr>

    <tr>

      <td align="right">&nbsp;</td>

      <td colspan="3" align="right"><input name="page" type="hidden" id="page" value="jual" />

      <input name="jenis" type="hidden" id="jenis" value="7" />

          <label>

          <input name="Save" type="submit" id="Save" value="Simpan Penjualan" />

        </label></td>

    </tr>

  </table>

  <input type="hidden" name="MM_update" value="add" />

  <input type="hidden" name="MM_insert" value="add" />

</form>

